{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Summary","B1","B2","B3","B4","B5","B6"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":49,"n_cols":3,"rows_kept":49,"merged":[[0,0,0,2],[36,0,36,2]]}
["SUMMARY OF BILLS"]
["BILL NO","DESCRIPTION","AMOUNT"]
["I1","CONTRACTOR NAME",{"$f":"'B1'!C4:D4","v":"<Company Name>"}]
[]
["B1","PRELIMINARIES AND GENERAL                           ",{"$f":"'B1'!D43","v":0}]
[]
["B2","AIR HANDLING UNIT",{"$f":"'B2'!H15","v":0}]
[]
["B3","DX SPLIT SYSTEMS",{"$f":"'B3'!H30","v":0}]
[]
["B4","FRESH AIR AND TRANSFER AIR SYSTEMS",{"$f":"'B4'!E81","v":0}]
[]
["B5","ABLUTION EXTRACT SYSTEMS",{"$f":"'B5'!E23","v":0}]
[]
["B6","MISCELLANEOUS ",{"$f":"'B6'!D41","v":0}]
[]
["B7","CONTINGENCY"]
[null,"SAFETY FILE","R"]
{"$rows_empty":13}
[1,"TOTAL EXCLUDING VAT",{"$f":"SUM(C3:C31)","v":0}]
[]
[2,"PLUS 15% VAT",{"$f":"(C32)*15%","v":0}]
[]
[3,"TOTAL TENDER PRICE",{"$f":"SUM(C32:C35)","v":0}]
[]
[]
[]
["TENDERER SIGNATURE:                                                          "]
[]
[]
["NAME:"]
[]
[]
["TEL/FAX NO'S:"]
[]
[]
["DATE:"]

{"sheet":"B1","index":1,"n_rows":43,"n_cols":4,"rows_kept":43,"merged":[[0,1,0,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[42,0,42,2]]}
[null,"BILL NO 1:  PRELIMINARIES & GENERAL"]
[]
[null,"CONTRACTOR INFO"]
["I1","CONTRACTOR NAME","<Company Name>"]
["I2","CONTACT PERSON"]
["I3","CONTACT NUMBER"]
["I4","CONTACT EMAIL"]
[]
[null,"DESCRIPTION","SUPPLY RATE","AMOUNT"]
[]
[null,"The Tenderer shall allow for all Preliminary and General costs as set out in Addendum A for the Principal Contract as well as for his own General costs.  Profit and mark-up shall be priced into the rates"]
[]
["1.0","Fixed Cost",null,0]
[]
["2.0","Adjustable with contract amount",null,0]
[]
["3.0","Adjustable with Contract Period",null,0]
[]
[null,"Note:"]
[null,"The rates in this document will be used during the negotiations for the projects cost mentioned in the specifications document. Adjustments will be made for escalations and items not mentioned in this bill."]
{"$rows_empty":22}
["BILL 1 TOTAL TO SUMMARY",null,null,{"$f":"SUM(D4:D42)","v":0}]

{"sheet":"B2","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,4,0,7],[14,3,14,6]]}
[{"$nulls":4},"BILL NO 2:  AIR HANDLING UNIT AND VRV/F UNIT"]
[]
[{"$nulls":3},"ITEM NO.","DESCRIPTION","SUPPLY \nRATE","INSTALLATION RATE","AMOUNT"]
[{"$nulls":3},"1","HYBRID AHU c/w VRF/V SYSTEMS"]
["g","CA 1",null,"1.1","AHU01"]
["g","CA 1",null,"1.1.1","Full Fresh Air Box c/w supply air coils, supply air fans, electrical element heating as well as primary and secondary filter  as per specification document and drawings",0,0]
["g","CA 1",null,"1.1.2","VRV/F Inverter Heat Pump Condensing Unit ",0,0]
["g","CA 1",null,"1.1.3","Ducting from AHU to Exisiting Ducting",0,0]
["g","CA 1",null,"1.1.4","SAG02 c/w plenum box & ducting from existing duct to SAG Plenum",0,0]
["g","CA 1",null,"1.1.5","SAG03 c/w plenum box & ducting from existing duct to SAG Plenum",0,0]
["g","CA 1",null,"1.1.6","Cleaning and sealing of exisiting ducting and ancillary fittings",0,0]
[]
[{"$nulls":4},"SUB TOTAL ITEM 1",null,null,{"$f":"SUM(H6:H11)","v":0}]
[]
[{"$nulls":3},"BILL 2 TOTAL TO SUMMARY",{"$nulls":3},{"$f":"H13","v":0}]

{"sheet":"B3","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,4,0,7],[29,3,29,6]]}
[{"$nulls":4},"BILL NO 3: SERVICING AND RECOMMISIONG OF DX SPLIT SYSTEMS"]
[]
[{"$nulls":4},"DESCRIPTION","UNIT","QTY","AMOUNT"]
["FLOOR","NAME",null,"1","Service and Recommision of DX Split Systems"]
[null,"SW1",null,"1.1","DX MIDWALL IDU/ODU (MSU01/SOM01)"]
[null,"SW1",null,"1.1.1","Major Service on Midwall Unit including Outdoor Condensing Unit as per requirements and data sheets set out in the specification ",0,3,{"$f":"F6*G6","v":0}]
[null,"SW1",null,"1.1.2","Recommisioning unit as close as possible to manufacturers specification ",0,3,{"$f":"F7*G7","v":0}]
[]
[null,"SW1",null,"1.2","DX MIDWALL IDU/ODU (MSU02/SOM02)"]
[null,"SW1",null,"1.2.1","Major Service on Midwall Unit including Outdoor Condensing Unit as per requirements and data sheets set out in the specification ",0,4,{"$f":"G10*F10","v":0}]
[null,"SW1",null,"1.2.1","Recommisioning unit as close as possible to manufacturers specification ",0,4,{"$f":"G11*F11","v":0}]
[]
[null,"SW1",null,"1.2","DX MIDWALL IDU/ODU (MSU03/SOM03)"]
[null,"SW1",null,"1.2.1","Major Service on Midwall Unit including Outdoor Condensing Unit as per requirements and data sheets set out in the specification ",0,4,{"$f":"G14*F14","v":0}]
[null,"SW1",null,"1.2.1","Recommisioning unit as close as possible to manufacturers specification ",0,4,{"$f":"G15*F15","v":0}]
[null,"SW1"]
[null,"SW1",null,"1.3","DX MIDWALL IDU/ODU (MSU04/SOM04)"]
[null,"SW1",null,"1.3.1","Major Service on Midwall Unit including Outdoor Condensing Unit as per requirements and data sheets set out in the specification ",0,2,{"$f":"G18*F18","v":0}]
[null,"SW1",null,"1.3.2","Recommisioning unit as close as possible to manufacturers specification ",0,2,{"$f":"G19*F19","v":0}]
[]
[null,"SW1",null,"1.4","DX UNDERCEILING IDU/ODU (SUI01/SUO01)"]
[null,"SW1",null,"1.4.1","Major Service on Under Ceiling Unit including Outdoor Condensing Unit  as per requirements and data sheets set out in the specification ",0,2,{"$f":"G22*F22","v":0}]
[null,"SW1",null,"1.4.2","Recommisioning unit as close as possible to manufacturers specification ",0,2,{"$f":"G23*F23","v":0}]
[]
[null,"SW1",null,"1.5","DX UNDERCEILING IDU/ODU (SUI02/SUO02)"]
[null,"SW1",null,"1.5.1","Major Service on Under Ceiling Unit including Outdoor Condensing Unit  as per requirements and data sheets set out in the specification ",0,1,{"$f":"G26*F26","v":0}]
[null,"SW1",null,"1.5.2","Recommisioning unit as close as possible to manufacturers specification ",0,1,{"$f":"G27*F27","v":0}]
[]
[]
[null,"OU4",null,"BILL 3 TOTAL TO SUMMARY",{"$nulls":3},{"$f":"SUM(H6:H28)","v":0}]

{"sheet":"B4","index":4,"n_rows":81,"n_cols":5,"rows_kept":81,"merged":[[0,1,0,4],[80,0,80,3]]}
[null,"BILL NO 4: FRESH AIR SYSTEMS"]
[]
[null,"DESCRIPTION","SUPPLY \nRATE","INSTALLATION RATE","AMOUNT"]
[]
["1","Existing Fresh air supply System 1 - (FAF-01)"]
["1.1","Reposition, Major Service and Balancing of Fan",0,0,{"$f":"D6+C6","v":0}]
["1.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D7+C7","v":0}]
["1.3","Ducting un-insulated from new position of fan to existing ducting",0,0,0]
["1.4","Flexible Collars ",0,0,0]
["1.5","Weather Louvres c/w Primary Pleated Filters ",0,0,0]
["1.6","Weather Cowl c/w Wire Mesh Screen ",0,0,{"$f":"D11+C11","v":0}]
["1.7","Butterfly Dampers",0,0,0]
["1.8","Supply Air Grilles (SAG01)",0,0,{"$f":"D13+C13","v":0}]
["1.9","250mm Stand c/w anti-vibration Pads",0,0,0]
["1.10","Pressure Sensors c/w Dirty Filter Indicator Lights",0,0,0]
["1.11","Annual Seasonal Timer ",0,0,{"$f":"D16+C16","v":0}]
[]
["2","Exisiting Fresh air supply System 2 - (FAF-02)"]
["2.1","Reposition, Major Service and Balancing of Fan",0,0,{"$f":"D19+C19","v":0}]
["2.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D20+C20","v":0}]
["2.3","Ducting un-insulated from new position of fan to existing ducting",0,0,0]
["2.4","Flexible Collars ",0,0,0]
["2.5","Weather Louvres c/w Primary Pleated Filters ",0,0,0]
["2.6","Weather Cowl c/w Wire Mesh Screen ",0,0,0]
["2.7","Butterfly Dampers",0,0,0]
["2.8","250mm Stand c/w anti-vibration Pads",0,0,0]
["2.9","Pressure Sensors c/w Dirty Filter Indicator Lights",0,0,0]
["2.10","Annual Seasonal Timer ",0,0,0]
[]
["3","Existing Fresh air supply System 3 - (FAF-03)"]
["3.1","Reposition, Major Service and Balancing of Fan",0,0,{"$f":"D31+C31","v":0}]
["3.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D32+C32","v":0}]
["3.3","Ducting un-insulated from new position of fan to existing ducting",0,0,0]
["3.4","Flexible Collars ",0,0,0]
["3.5","Weather Louvres c/w Primary Pleated Filters ",0,0,0]
["3.6","Weather Cowl c/w Wire Mesh Screen ",0,0,0]
["3.7","Butterfly Dampers",0,0,0]
["3.8","250mm Stand c/w anti-vibration Pads",0,0,0]
["3.9","Pressure Sensors c/w Dirty Filter Indicator Lights",0,0,0]
["3.10","Annual Seasonal Timer ",0,0,0]
[]
["3","Exisiting Fresh air supply System 4 - (FAF-04)"]
["3.1","Reposition, Major Service and Balancing of Fan",0,0,{"$f":"D43+C43","v":0}]
["3.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D44+C44","v":0}]
["3.3","Ducting un-insulated from new position of fan to existing ducting",0,0,0]
["3.4","Flexible Collars ",0,0,0]
["3.5","Weather Louvres c/w Primary Pleated Filters ",0,0,0]
["3.6","Weather Cowl c/w Wire Mesh Screen ",0,0,0]
["3.7","Butterfly Dampers",0,0,0]
["3.8","250mm Stand c/w anti-vibration Pads",0,0,0]
["3.9","Pressure Sensors c/w Dirty Filter Indicator Lights",0,0,0]
["3.10","Annual Seasonal Timer ",0,0,0]
[]
["3","Existing Fresh air supply System 5 - (FAF-05)"]
["3.1","Reposition, Major Service and Balancing of Fan",0,0,{"$f":"D55+C55","v":0}]
["3.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D56+C56","v":0}]
["3.3","Ducting un-insulated from new position of fan to existing ducting",0,0,0]
["3.4","Flexible Collars ",0,0,0]
["3.5","Weather Louvres c/w Primary Pleated Filters ",0,0,0]
["3.6","Weather Cowl c/w Wire Mesh Screen ",0,0,0]
["3.7","Butterfly Dampers",0,0,0]
["3.8","250mm Stand c/w anti-vibration Pads",0,0,0]
["3.9","Pressure Sensors c/w Dirty Filter Indicator Lights",0,0,0]
["3.10","Annual Seasonal Timer ",0,0,0]
[]
["2","New Fresh air supply System 6"]
["2.1","Fan (FAF-06)",0,0,{"$f":"D67+C67","v":0}]
["2.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D68+C68","v":0}]
["2.3","Sound Attenuators c/w flexible collars",0,0,0]
["2.4","Ducting un-insulated from FAF to existing ducting",0,0,0]
["2.5","Flexible ducting",0,0,0]
["2.6","Supply Air Grilles (SAG04)",0,0,0]
["2.7","Butterfly Dampers",0,0,0]
["2.8","Filter Box c/w Primary Pleated Filters ",0,0,0]
["2.9","Weather Cowl c/w Wire Mesh Screen ",0,0,0]
["2.10","250mm Stand c/w anti-vibration Pads",0,0,0]
["2.11","Pressure Sensors c/w Dirty Filter Indicator Lights",0,0,0]
["2.12","Annual Seasonal Timer ",0,0,0]
[]
[null,"SUB TOTAL ITEM 1",null,null,{"$f":"SUM(E6:E78)","v":0}]
["BILL 4 TOTAL TO SUMMARY",{"$nulls":3},{"$f":"E80","v":0}]

{"sheet":"B5","index":5,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,1,0,4],[22,0,22,3]]}
[null,"BILL NO 5: OFFICE EXTRACT SYSTEMS"]
[]
[null,"DESCRIPTION","SUPPLY RATE","INSTALLATION RATE","AMOUNT"]
["1","Male Ablution Extract System 1"]
["1.1","Reposition, Major Service and Balancing of Fan",0,0,{"$f":"D5+C5","v":0}]
["1.2","3 Phase - Soft Starter Control Mechanism ",0,0,{"$f":"D6+C6","v":0}]
["1.3","Ducting un-insulated from new position of fan to Extract Air Grilles",0,0,0]
["1.4","Flexible Collars ",0,0,0]
["1.5","Weather Louvre",0,0,0]
["1.6","Butterfly Dampers",0,0,0]
["1.7","Extract Air Grilles (EAG01)",0,0,0]
["1.8","250mm Stand c/w anti-vibration Pads",0,0,0]
["1.9","Annual Seasonal Timer ",0,0,0]
[]
["2","Female Ablution Extract System 2 - WF01"]
["2.1","Major Service and Balancing of Fan",0,0,{"$f":"SUM(C16:D16)","v":0}]
["2.2","Annual Seasonal Timer ",0,0,{"$f":"D17+C17","v":0}]
[]
[]
[null,"SUB TOTAL ITEM 1",null,null,{"$f":"SUM(E14:E19)","v":0}]
[]
[]
["BILL 5 TOTAL TO SUMMARY",{"$nulls":3},{"$f":"E20","v":0}]

{"sheet":"B6","index":6,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[0,1,0,3],[40,0,40,2]]}
[null,"BILL NO 6: MISCELLANEOUS"]
[]
[null,"DESCRIPTION","SUPPLY \nRATE","AMOUNT"]
[]
["1.0","General Items"]
["1.1","Safety File",0,{"$f":"C6","v":0}]
[]
["1.2","On Site Storage",0,{"$f":"C8","v":0}]
[]
["1.3","Rigging ",0,{"$f":"C10","v":0}]
[]
["1.4","As Built Drawings",0,{"$f":"C12","v":0}]
[]
["1.5","O & M Manuals",0,{"$f":"C14","v":0}]
[]
["1.6","Testing and Commissioning of Full HVAC Systems",0,{"$f":"C16","v":0}]
[]
["1.7","Maintenance Guarantee (12 Month)",0,{"$f":"C18","v":0}]
[]
[]
["2.0","All items that were not included in the BOQ but is required to ensure that all systems function properly and without fault. As well as all items specified in the tender spec that is not listed in the BOQ.",0,{"$f":"C21","v":0}]
[]
[null,"Note:"]
[null,"Please list all additional items on this Bill below"]
[]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[null,"-"]
[]
[]
[]
[]
["BILL 6 TOTAL TO SUMMARY",null,null,{"$f":"SUM(D4:D40)","v":0}]